PGCon2008 - Final - we hope
PGCon 2008
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Asko Oja |
| Schedule | |
|---|---|
| Day | Talks - second day (2008-05-23) |
| Room | B |
| Start time | 13:30 |
| Duration | 01:00 |
| Info | |
| ID | 78 |
| Event type | lecture |
| Track | Horizontal Scaling |
| Language | en |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
plProxy, pgBouncer, pgBalancer
Paritioning databases and using remote calls
There are several ways how plProxy can be useful in case of large sets of online data. It was designed for partitioning databases but now we have taken it into use also for remote calls. pgBouncer is natural part of plProxy installations.
I would like to describe some growth paths for a company and its databases. In the beginning it's usual to have one server and one database. Depending on success you may end up with any number of database servers. Load balancing with pgBalancer, pgBouncer and plProxy Using plProxy for remote calls Using plProxy for Partitoning